Database Management Basics

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to Lesson

Podcast

Play an AI-generated podcast conversation about this lesson
Download our mobile app to listen on the go
Get App

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

Flashcards are hidden until you start studying

More Like This

Use Quizgecko on...
Browser
Browser