Database Management Basics
10 Questions
1 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

Where can you go to change the default style in Excel?

  • Numbers tab (correct)
  • Formulas tab
  • Insert tab
  • Home tab

What is the first step to sort data in Excel?

  • Type '=' in the cell
  • Type the cells you'd like to include
  • Go to the toolbar and choose Data (correct)
  • Choose Sort in the Numbers tab

How do you add/subtract/multiply/divide data in Excel?

  • Choose Sort and then select the math symbol
  • Type the cells you'd like to include, using the correct math symbol (correct)
  • Type '=' followed by the math symbol in the cell
  • Go to the Home tab and select the math symbol

What do you need to type first to create a formula in Excel?

<p>'=' (B)</p> Signup and view all the answers

What kind of data can you include in your formula in Excel?

<p>A combination of numbers and text (B)</p> Signup and view all the answers

What is the first step to create a database in Microsoft Excel?

<p>Click on cells A1, B1, C1 to type in the column headings or field names (C)</p> Signup and view all the answers

What is the purpose of using databases in a computer system?

<p>To analyze and change information easily (C)</p> Signup and view all the answers

What should be done to add additional information columns to a database in Microsoft Excel?

<p>Right-click the top of the column and then select Insert Column (C)</p> Signup and view all the answers

What does Excel automatically do when you type in numbers such as a date?

<p>Automatically format them (A)</p> Signup and view all the answers

In what way can databases be used in a business setting?

<p>To keep track of employees’ information (C)</p> Signup and view all the answers

More Like This

Use Quizgecko on...
Browser
Browser