BCA Unit A excel

30 terms by unclegranny 

Ready to study?
Start with Flashcards

Create a new folder

Advertisement Upgrade to remove ads

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

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set