MS Excel
In Excel which of the following is not a worksheet design criterion
Description
In Excel the auto calculate feature
Provides a quick way to view the result of an arithmetic operation on a range of cells
In Excel..... is a group of cells that form a rectangle on the screen
Range
In Excel you can print
(A) A range of cells by range name (B) An entire workbook (C) A single worksheet
In Excel you can create hyperlinks from the Excel workbook to
(A) A webpage on company internet (B) A web page on the internet (C) Other Office application documents
In Excel you can insert labels for
(A) All the data markers on a chart (B) A data series (C) A selected data marker
In Excel Charts tips can
(B) Show the name of a data series (C) Show the value of data point
In Excel using the F11 shortcut key to create a chart on chart sheet creates
A 2-dimensional column chart
In Excel the chart wizard
Can only place a chart on new chart sheet
Comments put in cells are called
Cell tip
In Excel Comments put in cells are called
Cell tip
In Excel which of the following is not a valid data type in excel
Character
In Excel to select a column the easiest method is to
Click the column heading
In Excel following term describes explanatory text attached to a cell
Comment
In Excel LEN function does what
Compares the content in two cells
In Excel which elements of worksheet can be protected from accidental modification
Contents, Objects and Scenarios
Which of the following is not a basic step in creating a worksheet
Copy the worksheet
In Excel which do you press to enter the current date in a cell
Ctrl + ;
In Excel to access the Go To Special feature, you can press
Ctrl + G
In Excel to name a constant, you use the ...... dialog box
Define name
In Excel how do you change column width to fit the contents
Double click the boundary to the right of the column heading
In Excel when creating a vertical page break the active cell must be in
row 1
In Excel Hyperlinks can be
stars and banners and rectangles ovals
In Excel which menu option can be sued to split windows into two
Window > split
In Excel data marker on a chart are linked to data points in a worksheet, therefore
You can change the position of a data marker and automatically change the data point value in the worksheet
Which is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series
File handle
In Excel name box
In Excel name box
In Excel worksheet range is a
In Excel worksheet range is a
In Excel you can edit a cell by
In Excel you can edit a cell by
In Excel the following describes how to select all the cells in a single column
Left click on the gray column title button
In Excel when you insert an excel file into a word document. The data are
Linked
In Excel accounting style shows negative numbers in
Parentheses
In Excel to protect a worksheet, you can choose Protection and the Protect Sheet from the ..... ......menu
Review
In Excel you can open the Highlight Changes dialog box by choosing Track Changes from the .... Menu.
Review
To copy formatting from one area in a worksheet and apply it to another area you would use:
The Format Painter button on the standard toolbar
In Excel the Paste Special command lets you copy and paste
The resulting values of a formula instead of the actual formula
In Excel when you see a cell with a red triangle in the top right corner, what does this signify
There is a comment associated with the cell
In Excel intersection of a row and column is called
cell
In Excel two common wildcard characters that Excel recognizes are
* and ?
In Excel how many characters can be typed in a single cell
65,535
In Excel you can use the drag and drop method to
(A) Copy cell contents (B) Move cell contents
What excel feature can you use if you want to work with one record at a time
Data Form
In Excel you can quickly change the appearance of your work by choosing Auto Format from the ........... Menu
Format
In Excel to move to the previous worksheet, press
In Excel you can convert existing excel worksheet data an charts to an HTML document by using? Internet assistant wizard
In Excel it is acceptable ot let long text flow into adjacent cells on a worksheet when
No data will be entered in the adjacent cells
In Excel default style for new data keyed in a new workbook is
Normal
In Excel without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet
Press Ctrl +Home
Which of the following methods cannot be used to edit the contents of a cell In Excel
Press the Alt key
Which of the following will not cut information
Pressing Ctrl + C
How do you insert a row
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
In Excel term refers to a specific set of values saved with the workbook
Scenario
In Excel how can you delete a record
Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
How can you find specific information in a list
Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
How can you print three copies of a workbook
Select File >Print from the menu and type 3 in the Number of copies text box
In Excel to delete and embedded object, first
Select it and then press Delete key
In Excel to delete an embedded objects, first
Select it and then press the delete key
To create a formula, you first:
Select the cell you want to place the formula into
When the formula bar is active, you can see
a. The edit formula button b. The cancel button c. The enter button
In Excel Tab scrolling button Allow you to view
additional sheets tabs
Multiple calculations can be made in a single formula using
array formula
When integrating word and excel, word is usually the
b. Destination c. Client
Files created with Lotus 1-2-3 have an extension
123
In Excel chart wizard term data series refers to
A collection of chart data markers
In Excel on an excel sheet the active cell in indicated by
A dark wide boarder
In Excel circular reference is
A formula that either directly or indirectly depends on itself
In Excel Chart wizard term data categories refers to
A horizontal axis
In Excel what does SUMIF function do
Adds up cell values based on a condition
In Excel concatenation of text can be done using
Ampersand (&)
In Excel numeric value can be treated as a label value if it precedes with
Ampersand (&)
In Excel autofill feature
Automatically adds range of cell values
In Excel you can use drag and drop to embed excel worksheet data in a word document
By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key OR By displaying both applications side-byside and dragging a selected range of Excel data into the word application window while pressing the Ctrl key
In Excel the drag and drop method of copying or moving
Can be used between workbooks but not worksheets
In Excel suppose you have columns of data that span more than one printed page. How can you automatically print the column headings on each page
Click page setup on the file menu, click the sheet tab, and enter the row that contains these column headings under print titles.
How do you select an entire column
Click the column heading letter
In Excel you can use the formula palette to
Create and edit formulas containing functions
In Excel to open the Format Cells dialog box, press
Ctrl + 1
In Excel you can use the format painter multiple times before you turn it off by
Double clicking the format painter button In Excel default header for a worksheet is?None
In Excel you can select a single range of cells by
Dragging over the desired cells
In Excel the following is not information you can specify using the solver
Input cells
In Excel the following is not an underline option in the format cells dialog box
Single Engineering
In Excel 3-D reference in a formula
Spans worksheets
In Excel this type of software is similar to an accountant's worksheet
Spreadsheets
In Excel which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the resulting a difference cell
Sum
In Excel when you group worksheets
You can print more than one worksheet at a time OR You can enter common data, formats, and formulas on multiple worksheets at one time
Which is used to perform what if analysis
a. Solver b. Goal seek c. Scenario Manager
Which of the following is not a way to complete a cell entry
Pressing spacebar
Which of the following methods cannot be used to enter data in a cell
Pressing the Esc key
In Excel the following setup options cannot be set in the page setup dialog box
Printer selection
In Excel getting data from a cell located in a different sheet is called
Referencing
You cannot link Excel worksheet data to a Word document
With the copy and paste buttons on the standard toolbar
You can activate a cell by
a. Pressing the Tab key b. Clicking the cell c. Pressing an arrow key
In Excel typical worksheet has .... Number of columns
256
In Excel what symbol is used before a number to make it a label
= (equal)
In Excel All macro keyboard shortcuts include the ..... key
ALT
In Excel the view that puts a blue a blue line around each page that would be printed is the
Page Break Preview
How do you delete a column
Right click the column heading you want to delete and select delete from the shortcut menu
In Excel how do you insert a row
Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu
To center worksheet titles across a range of cells, you must
Select the cells containing the title text plus the range over which the title text is to be centered
In Excel to cancel the marquee, press
esc
In Excel if you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you press
esc button
The name box Appears to the
left of the formula bar
In Excel constant is another name for this type of data
number
There are three types of data found in a spreadsheet
numbers formulas, labels