Microsoft Excel Questions and Answers

Practice Mode
Showing 10 of 255 questions
Q171
In Excel what does SUMIF function do ?
  • A Adds up cell values based on a c ondition
  • B Adds all the numbers in a range of cells
  • C Returns a subtotal in a list or database
  • D All of above
Answer: Option A
Q172
In Excel you can insert labels for
  • A All the data markers on a chart
  • B A data series
  • C A selected data marker
  • D All of the above
Answer: Option D
Q173
In Excel Tab scrolling buttons
  • A Allow you to view a different worksheet
  • B Allow you to view additional worksheet row down
  • C Allow you to view additional worksheet columns to the right
  • D Allow you to view additional sheet tabs
Answer: Option D
Q174
In Excel All macro keyboard shortcuts include the .........key
  • A Alt
  • B Ctrl
  • C F11
  • D Shift
Answer: Option A
Q175
In Excel to open the Format Cells dialog box, press
  • A Alt + 1
  • B Ctrl + 1
  • C Ctrl + Sjoft + 1
  • D F1
Answer: Option B
Q176
In Excel you can add a hyperlink  to your worksheet by pressing
  • A Alt + K
  • B Ctrl + H
  • C Ctrl + K
  • D Ctrl + Shift + K
Answer: Option C
Q177
In Excel to move to the previous worksheet, press
  • A Alt + PgUp
  • B Ctrl + PgUp
  • C Ctrl + PgDn
  • D Shift + Tab
Answer: Option D
Q178
In Excel you can select a single range of cells by
  • A Clicking the upper-left cell in 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
Answer: Option D
Q179
In Excel which of these will not select all the cells in a document ?
  • A Clicking three times with the right mouse button in the spreadsheet
  • B Using the Edit Select all menu
  • C Pressing Ctrl + A on the keyboard
  • D Pressing Ctrl + A on the keyboard
Answer: Option A
Q180
In Excel you can use the formula palette to
  • A Format cells containing numbers
  • B Create and edit formulas containing functions
  • C Enter assumptions data
  • D Copy a range of cells
Answer: Option B

📚 More from Computer Science & Engineering(CSE)

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Computer Science & Engineering(CSE)
Back to Computer Science & Engineering(CSE)
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test