DIT Semester 2 Exam

Which of the following special characters is/are not used to identify values in Excel?

#, /

Which of the following extensions should be selected within the Save As dialog box to ensure compatibility with Excel 97?

.xls

How many worksheets are included in a new blank workbook?

1

What is the maximum number of characters allowed in a file name?

255

A/An __________, where you can type information, is outlined by a bold rectangle in your worksheet.

Active Cell

Which of the following is a selected cell?

Active Cell

When you add ribbon commands to the Quick Access Toolbar, right-click the command and choose __________.

Add to Quick Access Toolbar

Which key is used to display keyboard shortcuts (Keytips) on the ribbon?

Alt

Which of the following should you press to close both an open file and Excel at the same time?

Alt+F4

The __________ command on the View tab in the Workbook Views group opens windows side by side to compare sections of a large worksheet.

Arrange All

Which Excel feature is used to fill cells with data that is based on data in other cells or that follows a pattern?

Auto Fill

The __________ feature works only for entries that contain text or a combination of text and numbers.

AutoComplete

Which view shows the options to open, save, print, and manage your Excel file?

Backstage

Which of the following displays in the title bar when a new window is opened from the View tab?

Book1:2

What is the procedure to launch Excel from the Windows desktop?

Click the start button and then choose Microsoft Excel, Right click on the desk top and new , Microsoft Excel, and then double click it & Click the icon on the Windows task bar

What starts at the top of each worksheet, goes to the bottom, and is identified by a letter?

Column

The ribbon is organized into task-oriented __________.

Command Tabs

Which of the following places a duplicate of the selected information on the Clipboard?

Copy

What term is used to describe the pointer when it is an arrow with a plus?

Copy pointer

In order to copy data, which key do you hold down the entire time while dragging?

Ctrl

To display the Open dialog box, which of the following should you press?

Ctrl + F12

To get to the last cell on a worksheet, which of the following should you press

Ctrl+End

Which of the following is used to save the open workbook?

Ctrl+S

Which of the following is used to switch through open workbooks?

Ctrl+Tab

Which keys do you use to restore deleted text?

Ctrl+Z

Pressing __________ removes the cell's contents but does not remove any of the formatting applied to the cell.

Delete

An arrow in the bottom-right corner of a group on the ribbon tells you that which of the following is available?

Dialog box

What do you do to automatically expand the column width to fit cell contents?

Double-click using the double-headed arrow.

Which options are available in the Save As dialog box?

Drive location, file name, new folder & file type

Which key do you use to move to the next row when entering data?

Enter

By default, which of the following file types is displayed in the Excel Open dialog box?

Excel

Which command on the File tab is used to save the workbook as a different file type?

Export

Which of the following is the Keyboard Shortcut, used to access help?

F1

Ctrl+F displays the backstage view

FALSE

Ctrl+O Opens a new blank workbook

FALSE

Pressing the F1 key displays backstage?

FALSE

The Quick Access Toolbar appears on the right side of the title bar, above the ribbon

FALSE

The columns in a worksheet are identified by numbers

FALSE

The __________ tab contains the Backstage Open command.

File

Which tab do you select when you are ready to create a new workbook?

File

Which tab on the ribbon do you select to view Backstage options?

File

__________ is like Auto Fill, but Excel does more work.

Flash Fill

The commands on each ribbon tab are organized into logical command __________.

Groups

When you click the Help button what opens?

Help Window

On which tab will you find the Go To command?

Home

Which keys can be used to navigate within the formula bar during edit mode?

Home, End, Left Arrow, and Right arrow

Under which main Backstage command will you find the check compatibility option?

Info

Which command in Backstage displays details about the current file?

Info

In order to see additional customization options, select __________ from the Quick Access Toolbar drop-down list to display the Excel Options dialog box.

More Commands

By default in all Office applications, documents are saved to which of the following locations?

My Documents

Which of the following commands is similar to Split?

New Window

In the Workbook Views group, click __________ to display the active worksheet without rulers, headers, footers, or page breaks.

Normal

Under which Backstage option can you enable or disable the AutoComplete feature?

Options

What option on the View tab displays worksheet margins and page breaks and gives you an opportunity to add a header or footer?

Page Layout

Which of the following is used to insert a copied or cut selection into a cell or range of cells?

Paste

Which feature enables you yo preview headers and footers, page breaks, and other features that will print

Print Layout

Which toolbar is located in the upper left corner of the Excel window?

Quick Access

Which command within Backstage is used to consistently display the save options?

Save As

A __________ displays descriptive text when you rest the pointer on a command or control in Excel.

ScreenTip

Some Keyboards come equipped with a/an __________ key, which disables arrow key movement when activated.

Scroll Lock

To edit a cell, you must first do what?

Select the cell

Which of the following is a cloud-based application that allows you to store your files so you can retrieve them from anywhere and share them with others?

SkyDrive

In order to display additional search options, which button in the Go To dialog box should you use?

Special

The __________ command enables you to view large worksheets in two panes or four quadrants.

Split

Click the FILE tab to get to the backstage view

TRUE

Page Layout view is useful when preparing your data for printing

TRUE

Press Ctrl+Home to go to cell A1

TRUE

Pressing Alt key activates Keytips that allow you to use the keyboard to choose tabs instead of the click of a mouse

TRUE

The active cell in a worksheet us outlined by a bold rectangle

TRUE

Which new document type has already been set up to display data layout and formatting?

Template

Which of the following starts off with Open, Undo, Redo and can be customized to contain the commands you use most frequently?

The Quick Access toolbar

After a file has been opened, the file name appears in which of the following?

Title bar

What tab on the ribbon has the Split command, useful for viewing large worksheets?

View

Which tab holds commands for controlling the appearance of the active document?

View

A __________ is an Excel file made up of one or more worksheets.

Workbook

Where is the Select All button located in the worksheet?

above row 1 and to the left of column A

The Quick Access Toolbar can be moved __________.

above the ribbon and below the ribbon

A/An __________ is the name of a box in a worksheet at the intersection of a row and column in which information is typed.

cell

Which is the intersection of a row and column

cell

The Check for issues option can be described as the command used to ________.

check compatibility with earlier versions

To increase workspace you can __________ so that only the tabs display at the top of the screen.

collapse the ribbon

The Auto Fill tool is used for what purpose?

complete the series or copy the cell contents

Use the __________ on the bottom right side of the Quick Access Toolbar to add additional commands.

drop-down arrow

The __________ bar at the top of the Excel window can be used to enter or edit cell entries or formulas.

formula

Where is the Fill handle located?

in the right hand corner of a cell

What is the other term for numeric data entered in Excel?

labels

Which of the following represents a natural series in a spreadsheet?

months

The __________ changes to a double-headed arrow when placed between column header buttons to change column width.

mouse pointer

Use the __________ option for quick access to the Excel application from the Windows desktop.

pin

What is a group or block of cells in a worksheet that have been selected or highlighted?

range

The tools to edit the workbook are located on the __________.

ribbon

What starts at the left edge of each worksheet, extends to the right, and is identified by a number?

row

Excel AutoComplete bases the list of potential entries on the text located in the ________.

rows above

Where are the icons available to change views outside the ribbon?

status bar

Where is the information on the Office Clipboard stored?

temporary memory

If you cannot find the command you need while working in the ribbon, where can you click to find more options?

the Options arrow in the bottom right corner of the group

The Close command on the File tab closes __________.

the entire workbook

What is the purpose of the Name Box?

to indicate the current active cell(s)

when you split a window, the window is divided into how many panes

two or four

Excel provides the tools to create which type of documents?

workbooks