BCA Unit A excel

Unlock all answers in this set

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