Excel Module_1 test doc(1)

When you use the Windows Start menu to start Excel

it opens in Backstage view.

When you print in portrait orientation

the page is wider than it is tall.

When you enter a number

date

True or false A good practice is to move the most important worksheets to the end of the workbook.

False ✔️

To preview and print a workbook

click the File tab to display Backstage view.

True or False You can set a scaling option to resize a worksheet to fit within a single page.

True ✔️

True or False You can edit cell contents in the formula bar or in the cell itself.

True ✔️

To enter a typed number into a cell

you can press Tab or Backspace.

To increase the magnification of a worksheet from 100% to 120%

you use the Magnification slider.

In the formula =SUM(A6:A9)

what best describes A6:A9?

Which lets you edit the contents of a cell?

Double‑click the cell or click in the formula bar ✔️

Which view shows how a worksheet will appear when printed?

Page Layout ✔️

Which formula most efficiently adds B6:B10?

=SUM(B6:B10) ✔️

What appears in the print preview in Backstage view?

Worksheet data ✔️

How can you reverse an error immediately after confirming a cell entry?

Undo button ✔️ / CTRL+Z ✔️

To select a single worksheet cell

what do you do?

Which formula calculates the total value of a range?

=SUM(A3:A9) ✔️

How can you reverse your most recent action?

Undo button ✔️

Which key copies selected cells while dragging?

CTRL ✔️

Which formula adds 25 and 10

then multiplies by 50?

Worksheet too wide for portrait orientation — what do you do?

Change to landscape ✔️

Which ribbon tab provides print options like orientation and scaling?

Page Layout ✔️

Which option ensures the worksheet prints on one page?

Scaling ✔️

Temporary storage area for copied/cut selections?

Clipboard ✔️

A named operation that replaces an arithmetic expression is called a:

Function ✔️

If data is not of interest and better summarized elsewhere

consider _____ the worksheet.

Ways to insert a formula using a function:

Enter formula ✔️ / AutoSum ✔️ / AutoSum arrow ✔️ / Copy‑paste ✔️

Ways to create a new blank workbook:

New in Backstage ✔️ / CTRL+N ✔️

Double‑clicking the right border of a column heading does what?

AutoFit to widest entry ✔️

Default font size for worksheets:

11 ✔️

True or False Which is true about adding cell borders?

You can add borders to any edge ✔️

To prevent others from seeing confidential data in column C

you can:

Rows numbered 1

2

Count cells with numbers between B1 and B20:

=COUNT(B1:B20) ✔️

Count nonblank cells between B1 and B20:

=COUNTA(B1:B20) ✔️

True or False Flash Fill enters text based on patterns it finds.

True ✔️

Changing to Normal view changes worksheet contents.

False ✔️

Calculations in square brackets are calculated first.

False ✔️

True or false Clicking a cell to insert a reference requires typing a number to lock it.

False ✔️

To total a column of expenses:

AutoSum ✔️ / AutoSum arrow ✔️ / ALT+= ✔️

True or False Which is true about COUNT functions?

Counts numeric cells ✔️

Feature to fill remaining full names after typing first one:

Flash Fill ✔️

What indicates the column and row where a cell is located?

Cell reference ✔️

Where can you view the active cell reference?

Name box ✔️

Reduced view with blue dividers indicates:

Page Break Preview ✔️

How does Excel determine which calculation to perform first?

Order of operations ✔️

True or False Insert two blank rows above row 5 by clicking row 5 and Insert twice.

True ✔️

Copying cell contents removes data from original location.

False ✔️

True or False Which is true about moving cell contents?

Drag‑and‑drop ✔️

Excel retrieves the most recently copied formula when you:

Paste ✔️

Copying =SUM(E12:G12) from A12 to 3 rows below becomes:

=SUM(E15:G15) ✔️

After pasting formulas into a selected range:

Paste Options button appears ✔️

Which is NOT a way to move cell contents?

CTRL + drag (copies

True or False Cutting A1:A5 and pasting to C1:C5 — true statements:

A1:A5 become blank ✔️ / C1:C5 receive data ✔️

True or False Inserting a worksheet row inserts above the pointer and moves contents down.

True ✔️

True or False You can move a worksheet by dragging its sheet tab.

True ✔️

True or false Selected cells must be adjacent.

False ✔️

To paste a copied range

you only need to specify the upper‑right cell.

True or False Which is NOT true about setting column width?

You can change multiple columns at once (NOT true) ✔️

True or False Which is true about deleting a worksheet row?

Deletes data and cells ✔️

What happens to formulas when you insert a column?

Excel updates references ✔️

After deleting a column:

Cells to its right shift left ✔️

To add another product to row A (product names):

Add a column ✔️

To rename a worksheet

double‑click the sheet:

To select nonadjacent cells

hold:

Which type of data can you wrap within a cell?

Text ✔️

To redisplay a hidden worksheet

you:

Myra wants sensitive data hidden but still usable in formulas:

Hide the worksheet ✔️

True or false Showing gridlines on screen automatically prints them.

False ✔️

To preserve the original workbook

you should:

Where do you rename a workbook and adjust save location?

Save As dialog box ✔️

True or False: True statements about deleting a worksheet:

Right‑click → Delete ✔️ / Deleting removes all data ✔️

To save a workbook for the first time

use Save As.

True or false Copying a worksheet by holding SHIFT while dragging.

False ✔️

To add a worksheet

use the New sheet tab.

Which view shows headers and footers?

Page Layout view ✔️

Which display a worksheet as it will appear when printed?

Page Layout ✔️ / Print screen ✔️ / Page Break Preview ✔️

After inserting a new worksheet

what should you do?

Method to copy a worksheet within the same workbook:

CTRL + drag ✔️

To open another workbook

go to Backstage view → Open.

To wrap text

change the row height.

Methods to save an existing workbook to OneDrive:

Upload ✔️ / Save As to OneDrive ✔️

Helps move different parts of a worksheet into view:

Scroll bars ✔️

Fast way to enter a commonly used function:

AutoSum ✔️

True or False A template is a preformatted workbook with design/content.

True ✔️

True or False You can relocate a page break by dragging the dotted blue border.

True ✔️