Wednesday, June 21, 2023

MCQ: Unit III: Spreadsheet

 ..


Practice Test: Question Set - 01

1. The name box

    (A) Shows the location of the previously active cell
    (B) Appears to the left of the formula bar
    (C) Appears below the status bar
    (D) Appears below the menu bar

2. Hyperlinks can be

    (A) Text
    (B) Drawing objects
    (C) Pictures
    (D) All of above

3. To copy formatting from one area in a worksheet and apply it to another area you would use:

    (A) The Edit > Copy Format and Edit > Paste Format commands form the menu
    (B) The Copy and Apply Formatting dialog box, located under the Format > Copy and Apply menu
    (C) There is no way to copy and apply formatting in Excel – You have to do it manually
    (D) The Format Painter button on the standard toolbar

4. To edit 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

5. You can copy data or formulas

    (A) With the copy, paste and cut commands on the edit menu
    (B) With commands on the shortcut menu
    (C) With buttons on the standard toolbars
    (D) All of the above

6. You can convert existing excel worksheet data an charts to an HTML document by using

    (A) FTP wizard
    (B) Internet assistant wizard
    (C) Intranet wizard Intranet wizard
    (D) Import wizard

7. Each excel file is called a workbook because

    (A) It can contain text and data
    (B) It can be modified
    (C) It can contain many sheets including worksheets and chart sheets
    (D) You have to work hard to create it

8. The numbers in our worksheet look like this: You want them to look like this: $1,000.How can you accomplish this?

    (A) Select Format > Money from the menu
    (B) Click the Currency Style button on the formatting toolbar
    (C) You have to retype everything and manually add the dollar signs, commas, and decimals
    (D) None of these

9. Which of the following methods cannot be used to edit the contents of a cell?

    (A) Press the Alt key
    (B) Clicking the formula bar
    (C) Pressing the F2 key
    (D) Double clicking the cell

10. To save a workbook, you:

    (A) Click the save button on the standard toolbar from the menu
    (B) Press Ctrl + F5
    (C) Click Save on the Windows Start button
    (D) Select Edit>Save

View All Answers

01. Answer: Option B 02. Answer: Option D 03. Answer: Option D 04. Answer: Option A 05. Answer: Option D 06. Answer: Option B 07. Answer: Option C 08. Answer: Option B 09. Answer: Option A 10. Answer: Option A


Practice Test: Question Set - 02

1. Which of the following is a correct order of precedence in formula calculation?
    (A) Multiplication and division exponentiation positive and negative values
    (B) Multiplication and division, positive and negative values, addition and subtraction
    (C) Addition and subtraction, positive and negative values, exponentiation
    (D) All of above
2. Which of the following options is not located in the Page Setup dialog box?
    (A) Page Break Preview
    (B) Page Orientation
    (C) Margins
    (D) Headers and Footers
3. When you want to insert a blank imbedded excel object in a word document you can
    (A) Click the object command on the insert menu
    (B) Click the office links button on the standard toolbar
    (C) Click the create worksheet button on the formatting toolbar
    (D) Click the import excel command on the file menu
4. You can use the drag and drop method to
    (A) Copy cell contents
    (B) Move cell contents
    (C) Add cell contents
    (D) Both ‘a’ and ‘b’
5. Comments can be added to cells using
    (A) Edit > Comments
    (B) Insert > Comments
    (C) File > Comments
    (D) View > Comments
6. Which of the following is an absolute cell reference?
    (A) !A!1
    (B) $A$1
    (C) #a#1
    (D) A1
7. A worksheet can have a maximum of _______ Number of rows
    (A) 256
    (B) 1024
    (C) 32000
    (D) 65535
8. Getting data from a cell located in a different sheet is called _________
    (A) Accessing
    (B) Referencing
    (C) Updating
    (D) Functioning
9. Excel uniquely identifies cells within a worksheet with a cell name
    (A) Cell names
    (B) Column numbers and row letters
    (C) Column letters and row numbers
    (D) Cell locator coordinates
10. All worksheet formula
    (A) Manipulate values
    (B) Manipulate labels
    (C) Return a formula result
    (D) Use the addition operator
View All Answers
01. Answer: Option D 02. Answer: Option A 03. Answer: Option A 04. Answer: Option D 05. Answer: Option B 06. Answer: Option B 07. Answer: Option D 08. Answer: Option B 09. Answer: Option C 10. Answer: Option C

Practice Test: Question Set - 05

1. How many characters can be typed in a single cell in Excel?
    (A) 256
    (B) 1024
    (C) 32000
    (D) 65535
2. Tab scrolling button
    (A) Allow you to view a different worksheet
    (B) Allow you to view additional worksheet rows down
    (C) Allow you to view additional worksheet columns to the right
    (D) Allow you to view additional sheets tabs
3. The auto calculate feature
    (A) Can only add values in a range of cells
    (B) Provides a quick way to view the result of an arithmetic operation on a range of cells
    (C) Automatically creates formulas and adds them to a worksheet
    (D) Both A and C
4. Which of the following will not cut information?
    (A) Pressing Ctrl + C
    (B) Selecting Edit > Cut from the menu
    (C) Clicking the Cut button on the standard
    (D) Pressing Ctrl+X
5. How do you select an entire column?
    (A) Select Edit > Select > Column from the menu
    (B) Click the column heading letter
    (C) Hold down the shift key as you click anywhere in the column
    (D) Hold down the Ctrl key as you click anywhere in the column
6. How can you find specific information in a list?
    (A) Select Tools > Finder from the menu
    (B) Click the Find button on the standard toolbar
    (C) Select Insert > Find from the menu
    (D) Select Data > Form from the menu to open the Data Form dialog box and click the Criteria button
7. Multiple calculations can be made in a single formula using
    (A) Standard formulas
    (B) Array formula
    (C) Complex formulas
    (D) Smart formula
8. When you link data maintained in an excel workbook to a word document
    (A) The word document cannot be edit
    (B) The word document contains a reference to the original source application
    (C) The word document must contain a hyperlink
    (D) The word document contains a copy of the actual data
9. Which of the following is the oldest spreadsheet package?
    (A) VisiCalc
    (B) Lotus 1-2-3
    (C) Excel
    (D) StarCalc
10. Excel files have a default extension of
    (A) Xls
    (B) Xlw
    (C) Wk1
    (D) 123
View All Answers
01. Answer: Option D 02. Answer: Option D 03. Answer: Option B 04. Answer: Option A 05. Answer: Option B 06. Answer: Option D 07. Answer: Option B 08. Answer: Option B 09. Answer: Option A 10. Answer: Option A

Practice Test: Question Set - 06

1. Which of the following is not information you can specify using the solver?
    (A) Input cells
    (B) Constraints
    (C) Target cell
    (D) Changing cells
2. Excel worksheet cells work very similarly to what common element of the windows graphical user interface
    (A) Option buttons
    (B) List boxes
    (C) Text boxes
    (D) Combo boxes
3. You can select a single range of cells by
    (A) Clicking the upper-left cell in a group of cells and then pressing the Shift key while clicking the lower right cell in a group of cells
    (B) Pressing the Ctrl key while dragging over the desired cells
    (C) Pressing the Shift key and an arrow key
    (D) Dragging over the desired cells
4. To copy cell contents using drag and drop press the
    (A) End key
    (B) Shift key
    (C) Ctrl key
    (D) Esc key
5. Which of the following formulas will Excel Not be able to calculate?
    (A) =SUM(Sales)-A3
    (B) =SUM(A1:A5)*.5
    (C) =SUM(A1:A5)/(10-10)
    (D) =SUM(A1:A5)-10
6. Data can be arranged in a worksheet in a easy to understand manner using
    (A) Auto formatting
    (B) Applying styles
    (C) Changing fonts
    (D) All of above
7. Which of the following is not a way to complete a cell entry?
    (A) Pressing enter
    (B) Pressing any arrow key on the keyboard
    (C) Clicking the Enter button on the Formula bar
    (D) Pressing spacebar
8. To create a formula, you first:
    (A) Select the cell you want to place the formula into
    (B) Type the equals sign (=) to tell Excel that you’re about to enter a formula
    (C) Enter the formula using any input values and the appropriate mathematical operators that make up your formula
    (D) Choose the new command from the file menu
9. Which is used to perform what if analysis?
    (A) Solver
    (B) Goal seek
    (C) Scenario Manager
    (D) All of above
10. When the formula bar is active, you can see
    (A) The edit formula button
    (B) The cancel button
    (C) The enter button
    (D) All of the above

01. Answer: Option A 02. Answer: Option C 03. Answer: Option D 04. Answer: Option A 05. Answer: Option A 06. Answer: Option D 07. Answer: Option D 08. Answer: Option A 09. Answer: Option D 10. Answer: Option D
..
at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

MCQ: Unit: 1 Contemporary Technology

 1) The network of physical devices which are built-in with sensors, hardware and software? a) AI b) VR c) IOT d) Cloud computing 2) Which o...

  • MCQ: Unit V: Presentation
    Practice Test: Question Set - 01 1. Which command will you use in PowerPoint if you need to change the color of different objects without ch...
  • SOLVING THE MATHEMATICAL CHALLENGES IN EXCEL
    SOLVING TASKS IN EXCEL WITH EXAMPLES Excel users have applied long and successfully this program to solve various types of tasks in differen...
  • MCQ: Unit: 1 Contemporary Technology
     1) The network of physical devices which are built-in with sensors, hardware and software? a) AI b) VR c) IOT d) Cloud computing 2) Which o...