Mcq on Ms Excel Set 9

 

151.    To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the

a.   Unfreeze panes command on the window menu

b.   Freeze panes command on the window menu

c.   Hold titles command on the edit menu

d.   Split command on the window menu

Correct Answer: b

 

152.    Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?

a.   Use Ctrl to select all three cells, then click the paste button on the standard toolbar

b.   Copy the selected cell, then select the other two cells, click style on the Format menu, then click Modify

c.   Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to

d.   All of above

Correct Answer: c

 

153.    To edit data in an embedded Excel worksheet object in a Word document

a.   Use the Excel menu bar and toolbars inside the word application

b.   Edit the hyperlink

c.   Edit the data in a Excel source application

d.   Use the Word menu bar and toolbars

Correct Answer: a. Use the Excel menu bar and toolbars inside the word application

 

154.    Status indicators are located on the

a.   Vertical scroll bar

b.   Horizontal scroll bar

c.   Formula bar

d.   Formatting toolbar

Correct Answer: c

 

155.    You can open the scenario Manager dialog box by choosing scenarios from the ….. menu.

a.   View

b.   Insert

c.   Format

d.   Tools

Correct Answer: d

 

156.    You can open the Sort dialog box by choosing Sort from the ….. menu

a.   View

b.   Format

c.   Tools

d.   Data

Correct Answer: d

 

157.    when working in the page break preview, you can

a.   view exactly where each page break occurs

b.   add or remove page breaks

c.   change the print area

d.   all of above

Correct Answer: d

 

158.    A data map is helpful

a.   When you have too much data to chart

b.   To show a geographic distribution of data

c.   To compare data points

d.   To show changes in data over time

Correct Answer: b

 

159.    Rounding errors can occur

a.   When you use multiplication, division or exponentiation in a formula

b.   When you use addition and subtraction in a formula

c.   Because Excel uses hidden decimal places in computation

d.   When you show the results of formulas with different decimal places than the calculated results

Correct Answer: a

 

160.    You can copy data or formulas

a.   With the copy, paste and cut commands on the edit menu

b.   With commands on a shortcut menu

c.   With buttons on the standard toolbar

d.   All of the above

Correct Answer: d

MCQ Set 9:- MS-Excel - A set of Objective Questions or Multiple Choice Questions (MCQs) suitable for Computer Jobs Exam such as computer operator conducted by Public Service Commission (PSC) - Lok Sewa Ayog.
 

MS-Excel is a popular spreadsheet calculation application developed by Microsoft Inc.

 

 

161.    You can zoom a worksheet

a.   With the mouse pointer in Print Preview

b.   With the zoom button on the Print Preview toolbar

c.   With the Zoom command on the view menu

d.   All of the above

Correct Answer: d

 

162.    You can not link Excel worksheet data to a Word document

a.   With the right drag method

b.   With a hyperlink

c.   With the copy and paste special commands

d.   With the copy and paste buttons on the standard toolbar

Correct Answer: d. With the copy and paste buttons on the standard toolbar

 

163.    This type of software is similar to an accountant’s worksheet

a.   Word processing

b.   Database

c.   Spreadsheets

d.   Graphics

Correct Answer: c

 

164.    which function will calculate the number of workdays between 6/9/2004 and 8/12/2004?

a.   Workday

b.   Date

c.   Networkdays

d.   All of the above

Correct Answer: d

 

165.    Data marker on a chart are linked to data points in a worksheet, therefore,

a.   You can automatically apply formatting to a data series

b.   You can change the position of a data marker and automatically change the data point value in the worksheet

c.   You can change a data print value and automatically are draw the chart

d.   a and b

Correct Answer: b

 

166.    When you group worksheets

a.   You can enter variable data on multiple worksheets at one time

b.   You can print more than one worksheet at a time

c.   You can enter common data, formats, and formulas on multiple worksheets at one time

d.   b, and c

Correct Answer: d

 

167.    You can use the format painter multiple times before you turn it off by

a.   You can use the format painter button only one time when you click it

b.   Double clicking the format painter button

c.   Pressing the Ctrl key and clicking the format painter button

d.   Pressing Alt key and clicking the format painter button

Correct Answer: b

 

 

---

168.    The default header for a worksheet is

a.   Your name

b.   The date and time

c.   None

d.   The sheet tab name

Correct Answer: c