Microsoft Excel Cell Formatting
30 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the purpose of the 'Values & Number Formatting' option in Excel?

  • To paste values and formatting from copied cells
  • To paste only the values from the copied cells
  • To paste only the formatting from the copied cells
  • To paste values and all number formatting options from the copied cells (correct)

What can be inserted using the 'Illustrations' tab in Excel?

  • Charts and graphs
  • Headers and footers
  • Pictures, shapes, or artwork (correct)
  • Links to external URLs

What is the purpose of the 'SmartArt' feature in Excel?

  • To create charts and graphs
  • To provide a graphical representation of data in lists, organizational charts, and process diagrams (correct)
  • To insert pictures and shapes
  • To create hyperlinks to external URLs

What can be used to create a navigation structure in an Excel sheet?

<p>Hyperlinks (D)</p> Signup and view all the answers

What is the purpose of the 'WordArt' feature in Excel?

<p>To use different styling for text (A)</p> Signup and view all the answers

What is the purpose of the 'Links' feature in Excel?

<p>To create hyperlinks to external URLs or files (B)</p> Signup and view all the answers

What is the purpose of the Format Painter?

<p>To copy the format from the original cell location to the destination cell location (B)</p> Signup and view all the answers

What is the function of the Orientation option?

<p>To rotate text vertically or diagonally (B)</p> Signup and view all the answers

What is the purpose of the Merge & Center option?

<p>To combine one or more cells and place the content in the middle (C)</p> Signup and view all the answers

What is the function of the Conditional Formatting option?

<p>To format cells based on certain predefined conditions (B)</p> Signup and view all the answers

What is the purpose of the Paste Options in Excel?

<p>To provide different ways of pasting data from the clipboard (B)</p> Signup and view all the answers

What is the function of the Clear option in Excel?

<p>To delete everything in the cell or remove just the formatting, contents, comments, or hyperlinks (A)</p> Signup and view all the answers

What is the purpose of the Freeze Panes feature in Excel?

<p>To freeze particular rows and columns to keep them visible while scrolling (C)</p> Signup and view all the answers

What is the function of the Macros feature in Excel?

<p>To record and execute actions taken in Excel (B)</p> Signup and view all the answers

What is the purpose of the SUM function in Excel?

<p>To add all numbers in a range of cells (D)</p> Signup and view all the answers

What is the result of using the Split feature in Excel?

<p>The worksheet is divided into two parts for separate navigation (D)</p> Signup and view all the answers

What is the function of the View Tab in Excel?

<p>To switch between worksheet views and arrange multiple windows (D)</p> Signup and view all the answers

What is a Function in Excel?

<p>A predefined formula that performs calculations using specific values in a particular order (B)</p> Signup and view all the answers

What happens when the num_digits argument is greater than 0 in the ROUNDDOWN function?

<p>The number is rounded to the set number of decimal places. (C)</p> Signup and view all the answers

What is the main difference between the ROUND and ROUNDDOWN functions?

<p>The direction of the rounding, up or down. (C)</p> Signup and view all the answers

What is the purpose of the COUNT function?

<p>To count the number of cells that contain numbers. (C)</p> Signup and view all the answers

What is the main difference between the COUNT and COUNTIF functions?

<p>The criteria they use to count cells. (C)</p> Signup and view all the answers

What happens when the num_digits argument is 0 in the ROUNDDOWN function?

<p>The number is rounded to the nearest integer. (A)</p> Signup and view all the answers

What is the purpose of the ROUNDUP function?

<p>To round a number up, away from zero. (D)</p> Signup and view all the answers

What is the purpose of the range_lookup argument in the VLOOKUP function?

<p>Specifies if you want to find an approximate or an exact match (D)</p> Signup and view all the answers

What is the shortcut to insert the current date in a cell?

<p>Ctrl + ; (D)</p> Signup and view all the answers

What is the shortcut to select the entire worksheet?

<p>Ctrl + A (B)</p> Signup and view all the answers

What is the purpose of the shortcut Ctrl + F?

<p>Find and replace (C)</p> Signup and view all the answers

What is the shortcut to make selected text bold?

<p>Ctrl + B (C)</p> Signup and view all the answers

What is the shortcut to add a new worksheet?

<p>Alt, H, O, R (D)</p> Signup and view all the answers

More Like This

Use Quizgecko on...
Browser
Open
Browser
Browser