Exam 1: Getting Started With Excel

When you enter a value in a worksheet cell, it is automatically left-aligned.

When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward.

Which of the following is not a way to move cell contents?

Which worksheet view shows headers, footers, and rulers?

Which of the following helps you move around a worksheet that is too large to fit on the screen at once?

The default worksheet text is _____-point Calibri.

Which of the following lets you search for a function or select one from a category?

To paste a copied cell range, you only need to specify the upper right of the range where you want to paste it.

You can edit cell contents in the Formula bar or in the cell itself.

Which of the following tabs lets you see exactly how your worksheet looks before printing?

When you copy cell contents, the data is removed from its original location and placed on the Clipboard.

To customize the status bar, right click on the status bar to open the Customize Status Bar menu and uncheck the items that you don't want to show.

In a complex formula, how does Excel determine which calculation to perform first?

You can start Excel using the Start button on the Windows taskbar or a shortcut on your desktop.

To change the size of text to a particular percentage of the original text size in a Power View report, click on Power View tab > Themes group > Text Size.

Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in?

Changing a worksheet window to Normal view changes the contents of the worksheet.

To select nonadjacent cells or ranges on a worksheet, you can press and hold _____ while selecting each one.

When you copy and paste a formula to a new location, the formula's relative references do not change.

To view a worksheet without headers, margins, and rulers, use Page Layout view.