How can we help?

You can also find more resources in our Help Center.

30 terms

BCA Unit A excel

STUDY
PLAY
True
Tools on the Page Layout tab include a Page Setup group, where you can adjust print orientation, paper size, and page breaks
False
An excel workbook has the file extension .xml.
True
You are in edit mode any time you are entering or changing the contents of a cell
False
When the paper orientation is set on landscape, the contents will print across the width of the page
true
your use formulas in Excel to perform calculations such as adding, multiplying, and averaging
True
in page layout view, the dotted line indicates the print area
false
page layout view shows the worksheet without including certain details like headers and footers or tools like rulers and a page number indicator
false
in an electronic spreadsheet, you need to manually recalculate when you change the entries
true
charts are updated automatically in Excel whenever data changes
false
arguments are excel's built in formulas
workbook
in excel, a worksheet is contained in a file called a ______
worksheet
in excel, the electronic spreadsheet you work in is called a __________
templates
you can use predesigned, formatted files called _____ to create new worksheets quickly
spreadsheet
an electronic _______ is an application you use to perform numeric calculations and to analyze and present numeric data
scroll bars
you can use ____ to move around in a document that is too large to fit on the screen at once
create what if scenarios
you can use a spreadsheet to _________ using variable values to investigate and sample different outcomes
^(caret)
the excel operator for exponent is ____
/
the excel operator for division is _____
=
all excel formulas begin with the _____-
labels
______ are entries that contain text and numerical information not used in calculations
+,-,=,@,#,$
excel recognizes an entry as a value if it is a number or begins with ____
arguments
____________ consists of the information needed by a function to calculate an answer
[ctrl][home]
to quickly jump to the first cell in a worksheet press_______
arrow
you can use the __________ keys on the keyboard to navigate a worksheet
double click the cell, click the formula bar, or just start typing
you can edit the contents of an active cell by _________
[alt][page up]
to move a screen to the left press
=
in a worksheet, _________ is called the formula prefix
turn on and off gridlines and headlines
in the sheet options group on the page layout tab, you can
portrait
possible paper orientations for printing a worksheet are landscape and __________
arithmetic
____________ operators perform mathmatical calculations such as adding and subtracting