BCA- unit A

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
you 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 excels 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 to analyze and present numeric data
answer
Spreadsheet
question
You can use a _____ to move around in a document that is too large to fit on the screen at once
answer
Scroll Bar
question
You can use a spreadsheet to _____ by using variable values to investigate and sample different outcomes
answer
Create a what-if scenarios
question
below the worksheet grid let you switch from sheet to sheet in a workbook
answer
Sheet Tabs
question
The Excel operator for exponent is ___
answer
^
question
The Excel operator for division is ___
answer
/
question
All Excel formulas begin with __
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 it begins with ____
answer
+ - = @ # $
question
consist 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
Typing in the formula bar
question
To move a screen to the left press __
answer
Alt Page Up
question
In the sheet options group of the page layout tab you can __
answer
Turn on/off grid lines
question
Possible paper orientations for printing a worksheet are landscape and ___
answer
Portrait
question
operators perform mathematical 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